﻿SET IDENTITY_INSERT cms_sys_ParamType ON   
delete from cms_sys_ParamType
insert into cms_sys_ParamType(ParamTypeId,Name,KeyWord,IsSysParam)
 values 
('1','系统设置','BaseParam','True')
insert into cms_sys_ParamType(ParamTypeId,Name,KeyWord,IsSysParam)
 values 
('2','模板变量','TemplateVars','True')
insert into cms_sys_ParamType(ParamTypeId,Name,KeyWord,IsSysParam)
 values 
('3','内容编辑器','ContentEditor','True')
insert into cms_sys_ParamType(ParamTypeId,Name,KeyWord,IsSysParam)
 values 
('4','内容分页生成器','ContentPager','True')
SET IDENTITY_INSERT cms_sys_ParamType OFF
GO
SET IDENTITY_INSERT cms_sys_TimeZone ON   
delete from cms_sys_TimeZone
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('1','零时区','0')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('2','东1区','1')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('3','东2区','2')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('4','东3区','3')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('5','东4区','4')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('6','东5区','5')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('7','东6区','6')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('8','东7区','7')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('9','东8区','8')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('10','东9区','9')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('11','东10区','10')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('12','东11区','11')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('13','东12区','12')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('14','西1区','-1')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('15','西2区','-2')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('16','西3区','-3')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('17','西4区','-4')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('18','西5区','-5')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('19','西6区','-6')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('20','西7区','-7')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('21','西8区','-8')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('22','西9区','-9')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('23','西10区','-10')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('24','西11区','-11')
insert into cms_sys_TimeZone(TimeZoneId,Name,TimeLag)
 values 
('25','西12区','-12')
SET IDENTITY_INSERT cms_sys_TimeZone OFF
GO
SET IDENTITY_INSERT cms_sys_PSN ON  
delete from  cms_sys_PSN
insert into cms_sys_PSN(psnid,Name,Type,Url,Root,Description,AddTime,Xml,TimeZoneId)
 values 
('1','本地HTML发布','0','http://cms.york.com','/','本地HTML发布','1900-1-1 0:00:00','','1')
SET IDENTITY_INSERT cms_sys_PSN OFF
GO 
SET IDENTITY_INSERT cms_model_FormInputLimitType ON
delete from cms_model_FormInputLimitType
insert into cms_model_FormInputLimitType(FormInputLimitTypeId,Name,RegStr,KeyWord)
 values 
('1','无任何限制','[\S\s]*','NULL')
insert into cms_model_FormInputLimitType(FormInputLimitTypeId,Name,RegStr,KeyWord)
 values 
('2','不能为空','\S','notNULL') 
insert into cms_model_FormInputLimitType(FormInputLimitTypeId,Name,RegStr,KeyWord)
 values 
('3','HTML标记','<(\S*?)[^>]*>.*?</\1>|<.*? />','IsHtml')
insert into cms_model_FormInputLimitType(FormInputLimitTypeId,Name,RegStr,KeyWord)
 values 
('4','Email地址','\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*','IsEmail')
insert into cms_model_FormInputLimitType(FormInputLimitTypeId,Name,RegStr,KeyWord)
 values 
('5','网址URL','[a-zA-z]+://[^\s]*','IsURL')
insert into cms_model_FormInputLimitType(FormInputLimitTypeId,Name,RegStr,KeyWord)
 values 
('6','国内电话号码','\d{3}-\d{8}|\d{4}-\d{7}','IsChinaTel')
insert into cms_model_FormInputLimitType(FormInputLimitTypeId,Name,RegStr,KeyWord)
 values 
('7','QQ','[1-9][0-9]{4,}','IsQQ')
insert into cms_model_FormInputLimitType(FormInputLimitTypeId,Name,RegStr,KeyWord)
 values 
('8','大于0的整数','^d+$/','bigZero')
insert into cms_model_FormInputLimitType(FormInputLimitTypeId,Name,RegStr,KeyWord)
 values 
('9','英文字母组成','^[A-Za-z]+$','IsEnChar')
SET IDENTITY_INSERT cms_model_FormInputLimitType OFF
GO
SET IDENTITY_INSERT cms_model_FormInputType ON   
delete from cms_model_FormInputType
insert into cms_model_FormInputType(FormInputTypeId,Name,FormItem,Description,AddTime,AddUserId)
 values 
('1','text','text','text','2010-10-9 10:41:48','0')
insert into cms_model_FormInputType(FormInputTypeId,Name,FormItem,Description,AddTime,AddUserId)
 values 
('2','textarea','textarea','textarea','2010-10-9 11:31:19','0')
insert into cms_model_FormInputType(FormInputTypeId,Name,FormItem,Description,AddTime,AddUserId)
 values 
('4','radio','radio','radio','2010-10-9 10:53:45','0')
insert into cms_model_FormInputType(FormInputTypeId,Name,FormItem,Description,AddTime,AddUserId)
 values 
('5','select','select','select','2010-10-9 10:54:45','0')
insert into cms_model_FormInputType(FormInputTypeId,Name,FormItem,Description,AddTime,AddUserId)
 values 
('6','checkbox','checkbox','checkbox','2010-10-9 11:18:50','0')
insert into cms_model_FormInputType(FormInputTypeId,Name,FormItem,Description,AddTime,AddUserId)
 values 
('7','ckeditor','ckeditor','ckeditor','2010-10-20 11:57:58','0')
insert into cms_model_FormInputType(FormInputTypeId,Name,FormItem,Description,AddTime,AddUserId)
 values 
('8','contentlink','contentlink','其它结点内容','2010-11-16 14:48:32','0')
SET IDENTITY_INSERT cms_model_FormInputType OFF
 
SET IDENTITY_INSERT [cms_model_FormInputValueType] ON
DELETE FROM [cms_model_FormInputValueType]
INSERT INTO [cms_model_FormInputValueType]  (FormInputValueTypeId , [Name] ,[KeyWord] ,[Step] ,[Description] ,[AddTime] ,[AddUserId])
     VALUES  (1,'无' ,'NoneData'    ,'1'  ,'无类型'  ,GETDATE()      ,1)
SET IDENTITY_INSERT [cms_model_FormInputValueType] OFF
GO
SET IDENTITY_INSERT cms_node_ContentPubType ON   
insert into cms_node_ContentPubType(ContentPubTypeId,Name,IsStatic,DisposeNum)
 values 
('1','静态发布','True','0')
insert into cms_node_ContentPubType(ContentPubTypeId,Name,IsStatic,DisposeNum)
 values 
('2','动态发布','False','0')
insert into cms_node_ContentPubType(ContentPubTypeId,Name,IsStatic,DisposeNum)
 values 
('3','不对外发布','False','0')
SET IDENTITY_INSERT cms_node_ContentPubType OFF
GO
SET IDENTITY_INSERT cms_node_NodeType ON   
insert into cms_node_NodeType(NodeTypeId,Name,KeyWord)
 values 
('1','实结点','node')
insert into cms_node_NodeType(NodeTypeId,Name,KeyWord)
 values 
('2','虚结点','node')
SET IDENTITY_INSERT cms_node_NodeType OFF
GO
SET IDENTITY_INSERT cms_sys_ContentWorkFlow ON   
insert into cms_sys_ContentWorkFlow(ContentWorkFlowId,Name,Description)
 values 
('1','---工作流禁止（不允许投稿）---','---工作流禁止（不允许投稿）---')
insert into cms_sys_ContentWorkFlow(ContentWorkFlowId,Name,Description)
 values 
('2','一级审核','一级审核')
insert into cms_sys_ContentWorkFlow(ContentWorkFlowId,Name,Description)
 values 
('3','二级审核','二级审核')
SET IDENTITY_INSERT cms_sys_ContentWorkFlow OFF
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[cms_content_1]') AND type in (N'U'))
DROP TABLE [dbo].[cms_content_1]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[cms_content_1](
	[cms_content_1id] [int] IDENTITY(1,1) NOT NULL,
	[Title] [nvarchar](250) NULL,
	[TitleColor] [nvarchar](7) NULL,
	[Photo] [nvarchar](250) NULL,
	[FromSite] [nvarchar](250) NULL,
	[Author] [nvarchar](20) NULL,
	[Content] [text] NULL,
	[Keywords] [nvarchar](250) NULL,
	[SubTitle] [nvarchar](250) NULL,
	[Editor] [nvarchar](20) NULL,
	[Intro] [text] NULL,
	[CustomLinks] [text] NULL,
 CONSTRAINT [PKcms_content_1] PRIMARY KEY NONCLUSTERED 
(
	[cms_content_1id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'信息标识' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cms_content_1', @level2type=N'COLUMN',@level2name=N'cms_content_1id'
GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_cms_content_2_LocalUpload]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[cms_content_2] DROP CONSTRAINT [DF_cms_content_2_LocalUpload]
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[cms_content_2]') AND type in (N'U'))
DROP TABLE [dbo].[cms_content_2]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[cms_content_2](
	[cms_content_2id] [int] IDENTITY(1,1) NOT NULL,
	[SoftName] [nvarchar](250) NULL,
	[Photo] [nvarchar](250) NULL,
	[LocalUpload] [nvarchar](250) NULL,
	[SoftType] [nvarchar](50) NULL,
	[SoftSize] [nvarchar](250) NULL,
	[Language] [nvarchar](10) NULL,
	[Environment] [nvarchar](50) NULL,
	[Star] [nvarchar](250) NULL,
	[SoftKeywords] [nvarchar](250) NULL,
	[Developer] [nvarchar](250) NULL,
	[Intro] [text] NULL,
	[Download] [nvarchar](250) NULL,
	[CustomSoftLinks] [nvarchar](250) NULL,
	[CustomLinks] [nvarchar](250) NULL,
 CONSTRAINT [PKcms_content_2] PRIMARY KEY NONCLUSTERED 
(
	[cms_content_2id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'信息标识' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cms_content_2', @level2type=N'COLUMN',@level2name=N'cms_content_2id'
GO
ALTER TABLE [dbo].[cms_content_2] ADD  CONSTRAINT [DF_cms_content_2_LocalUpload]  DEFAULT (N'LocalUpload') FOR [LocalUpload]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[cms_content_3]') AND type in (N'U'))
DROP TABLE [dbo].[cms_content_3]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[cms_content_3](
	[cms_content_3id] [int] IDENTITY(1,1) NOT NULL,
	[Title] [nvarchar](250) NULL,
	[Author] [nvarchar](50) NULL,
	[Size] [nvarchar](20) NULL,
	[Photo] [nvarchar](250) NULL,
	[FlashSrc] [nvarchar](250) NULL,
	[Intro] [text] NULL,
	[CustomLinks] [nvarchar](250) NULL,
 CONSTRAINT [PKcms_content_3] PRIMARY KEY NONCLUSTERED 
(
	[cms_content_3id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'信息标识' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cms_content_3', @level2type=N'COLUMN',@level2name=N'cms_content_3id'
GO
SET IDENTITY_INSERT cms_model_Model ON
delete from cms_model_Model
insert into cms_model_Model(ModelId,Name,TableName,Description,AddTime,AddUserId,UpdateTime,UpdateUserId)
 values 
('1','新闻系统模型','cms_content_1','','2010/11/30 14:54:24','0','2010/11/30 14:54:24','0')
insert into cms_model_Model(ModelId,Name,TableName,Description,AddTime,AddUserId,UpdateTime,UpdateUserId)
 values 
('2','下载系统模型','cms_content_2','','2010/11/30 15:19:11','0','2010/11/30 15:19:11','0')
insert into cms_model_Model(ModelId,Name,TableName,Description,AddTime,AddUserId,UpdateTime,UpdateUserId)
 values 
('3','图片系统模型','cms_content_3','','2010/11/30 15:48:43','0','2010/11/30 15:48:43','0')
SET IDENTITY_INSERT cms_model_Model OFF
GO
SET IDENTITY_INSERT cms_model_ModelField ON
delete from cms_model_ModelField
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('1','2','1','1','标题','Title','True','False','True','nvarchar','250','','0','True','True','True','True','none','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('2','1','1','1','标题颜色','TitleColor','False','False','False','nvarchar','7','','0','True','False','False','False','color','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('3','1','1','1','新闻图片','Photo','False','False','False','nvarchar','250','','0','False','False','False','False','upload_img','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('4','1','1','1','来源网站','FromSite','False','False','False','nvarchar','250','','0','False','False','False','False','none','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('5','1','1','1','作者','Author','False','False','True','nvarchar','20','','0','True','True','False','False','none','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('6','1','1','1','新闻内容','Content','False','True','False','text','250','','0','True','False','False','False','none','7')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('7','1','1','1','关键字','Keywords','False','False','False','nvarchar','250','','0','False','True','False','False','none','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('8','1','1','1','副标题','SubTitle','False','False','False','nvarchar','250','','0','True','True','False','False','none','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('9','1','1','1','责任编辑','Editor','False','False','False','nvarchar','20','','0','False','False','False','False','none','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('10','1','1','1','简介','Intro','False','False','False','text','250','','0','True','False','False','False','none','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('11','1','1','1','自定义相关文章','CustomLinks','False','False','False','text','250','','0','False','False','False','False','none','8')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('12','2','1','2','软件名称','SoftName','True','False','True','nvarchar','250','','0','True','True','True','False','none','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('13','1','1','2','界面预览','Photo','False','False','False','nvarchar','250','','0','True','False','True','False','upload_img','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('14','1','1','2','本地上传','LocalUpload','False','False','False','nvarchar','250','LocalUpload','0','True','False','True','False','upload_attach','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('15','1','1','2','软件类别','SoftType','False','False','False','nvarchar','50','','0','True','True','True','False','none','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('16','1','1','2','软件大小','SoftSize','False','False','False','nvarchar','250','','0','True','False','True','False','none','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('17','1','1','2','软件语言','Language','False','False','False','nvarchar','10','','0','True','True','True','False','none','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('18','1','1','2','运行环境','Environment','False','False','False','nvarchar','50','','0','True','True','True','False','none','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('19','1','1','2','软件评级','Star','False','False','False','nvarchar','250','','0','True','False','True','False','none','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('20','1','1','2','软件关键字','SoftKeywords','False','False','False','nvarchar','250','','0','True','True','True','False','none','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('21','1','1','2','开 发 商','Developer','False','False','False','nvarchar','250','','0','True','True','True','False','none','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('22','1','1','2','软件介绍','Intro','False','True','False','text','250','','0','True','False','True','False','none','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('23','1','1','2','下载地址','Download','False','False','False','nvarchar','250','','0','True','False','True','False','none','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('24','1','1','2','自定义相关软件','CustomSoftLinks','False','False','False','nvarchar','250','','0','False','False','False','False','none','8')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('25','1','1','2','自定义相关文章','CustomLinks','False','False','False','nvarchar','250','','0','False','False','False','False','none','8')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('26','1','1','3','图片名称','Title','True','False','True','nvarchar','250','','0','True','True','True','True','none','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('27','1','1','3','图片作者','Author','False','False','False','nvarchar','50','','0','True','False','True','True','none','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('28','1','1','3','图片文件大小','Size','False','False','False','int','20','','0','True','False','True','True','none','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('29','1','1','3','图片地址','Photo','False','False','False','nvarchar','250','','0','True','False','True','False','upload_img','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('31','1','1','3','图片介绍','Intro','False','True','False','text','250','','0','True','False','True','False','none','1')
insert into cms_model_ModelField(ModelFieldId,FormInputLimitTypeId,FormInputValueTypeId,ModelId,Name,FieldName,IsTitleField,IsMainField,FieldListDisplay,FieldTypeStr,FieldLength,DefaultValue,DisplayOrder,IsContribute,IsSearch,IsCollect,IsEdit,FieldInputPicker,FormInputTypeId)
 values 
('32','1','1','3','相关图片','CustomLinks','False','False','False','nvarchar','250','','0','True','False','True','True','none','8')
SET IDENTITY_INSERT cms_model_ModelField OFF
